home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
TPUG - Toronto PET Users Group
/
TPUG Users Group CD
/
TPUG Users Group CD.iso
/
MSDOS
/
(m)aac
/
SPREAD.MSG
< prev
next >
Wrap
Text File
|
1985-10-04
|
4KB
|
199 lines
Set Upper Value of Range
Set Lower Value of Range
Define the number of digits to right of decimal
Number of steps on Axis
Plot an X-Y graph, lines,symbols or both
Plot a Bar Graph
Not available
Return to previous menu.
Set Global Format for numbers.
Create Empty rows/columns
Eliminate rows/columns
Width range,1-70 characters
Automatic,Manual Calc, Status
Erase the Entire Worksheet
Return to the spreadsheet
Replace the Existing file
Adjust the Column Width
Restore to Global Format
Automatic Recalculation
Manual Recalculation , press F9
Erase the whole worksheet
Global, Insert, Delete, Column-Width, Status, Erase
Format, Erase, Input.
Copy a cell or range of cells.
Move a cell or range of cells.
Retrieve, Save, Merge, Xtract, Erase, List, Dir.
Range, Line, Page, Options, Setup.
Type, X, A, B, C, Titles, Scale
Exit from the Current Session ?
Define the range to be printed.
Advance Printer one line
Advance to top of Next Page
Margins, Headers, Footers, Control Codes
Set the current printer line as the top of Page
Print the Selected Range
Column(s) at cursor postion
Row(s) at cursor position
Retrieve Worksheet file
Save Worksheet file
Merge file into existing spreadsheet
Extract a portion of the file
Erase a worksheet file
List worksheet files
Change current directory
Format a Range of Data
Erase a Range of Data
Input a Range of Data
Lines, Symbols, Both
Define the X-axis Data Range
Define the First Data Range
Define the Second Data Range
Define the Third Data Range
Titles, Graph Color
Set Max and Minimum Scales
Plot the Graph
Main, Secondary, Horizontal, Vertical
Set graph color to green
Set graph color to brown
Define the Graphs Main Title
Graphs Secondary Title
Define the X-axis Title
Define the Y-axis Title
Return to Graph Menu
Define the Maximum and Minimum Horizontal values.
Define the Maximum and Minimum Vertical values.
Cancel Scale Settings.
Return to previous Menu.
Plot graph with lines
Plot with symbols
Use both symbols and lines
Fix the digits xx.yy.
Scientific Notation xxE+xx
Comma Notation xx,xxx,xxx.xx
Dollar notation $xx.xx
General format (trailing zeros truncated)
Percent (value x 100) notation xx.xx%
Set left Margin
Set Right Margin
Define Setup String to Printer
Set number of lines in page
Define message to appear at top of page
Define message to appear at bottom of page
Manual recalculation ( F9 initiates calc )
Automatic Recalculation ( all referenced cells )
Maximum Number of calculation Iterations
Set Global Format,
Set Global Column Width.
-
+
-
*
/
^
=
<>
>=
<=
<
>
AND
OR
NOT
#
#
#
#
#
#
#
#
NA
#
ABS
INT
SQRT
LOG
LN
PI
SIN
COS
TAN
SQR
ATAN
ASIN
ACOS
EXP
MOD
#
#
#
TRUE
FALSE
RAND
DATE
TODAY
PMT
PV
FV
IF
DAY
MONTH
YEAR
ROUND
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
SUM
AVG
COUNT
MIN
MAX
VLOOKUP
NPV
VAR
STD
IRR
HLOOKUP
SINH
COSH
TANH
ASINH
ACOSH
ATANH
#
=============================================================================
You are encouraged to copy and share this program with other users under the
conditions that the program is not distributed in modified form, that no fee
or consideration is charged, and that this notice is not bypassed or removed.
=============================================================================
'AS-EASY-AS' is a SPREADSHEET with Cell Editing, Block Moves, Block Copies,
Formulas, Functions, Range Formating and Graph plotting. Standard mathematical
operations are supported. Files may be Saved, Retrieved and Printed.
Available functions are the Statistical, Financial, Logical and
standard Mathematical functions. An incomplete list of those functions is;
@SIN @ASIN @SQRT @EXP @MOD @SUM @COUNT @PV @IF @SINH @ASINH
@COS @ACOS @LOG @PI @INT @STD @MAX @PMT @TRUE @COSH @ACOSH
@TAN @ATAN @LN @RAND @ABS @VAR @MIN @FV @FALSE @TANH @ATANH
If you feel this program is useful and worth your 'money' then please send
$25.00 US for the latest version and documentation. Make check payable to:
'David Schulz', Address: 15 Atkinson St., Lynn, MA. 01905.